Domination Normal Form - Decomposing Relational Database Schemas
نویسنده
چکیده
A common approach in designing relational databases is to start with a universal relation schema, which is then decomposed into multiple subschemas. A good choice of subschemas can be determined using integrity constraints defined on the schema, such as functional, multivalued or join dependencies. In this paper we propose and analyze a new normal form based on the idea of minimizing overall storage space. This is in contrast to existing normal forms such as BCNF, 4NF or KCNF, which only characterize the absence of redundancy (and thus spaceminimality) for a single schema.
منابع مشابه
Database Conceptual Schema Matching
Schema matching is a critical step in integration of heterogeneous data sources. properties and/or include other concepts and having Database. a novel, semi-automated and generic schema matching process. Prison Break solves the established practice (5), widely used for database migration and ontology where similar domain concepts may not be be identifiable via linguistic. Database / Oracle Data...
متن کاملNeutrosophic Relational Database Decomposition
In this paper we present a method of decomposing a neutrosophic database relation with Neutrosophic attributes into basic relational form. Our objective is capable of manipulating incomplete as well as inconsistent information. Fuzzy relation or vague relation can only handle incomplete information. Authors are taking the Neutrosophic Relational database [8], [2] to show how imprecise data can ...
متن کاملExtraction of Object-oriented Schemas from Existing Relational Databases: a Form-driven Approach
In this paper, we present our Form-driven approach for reverse engineering of relationa databases. This methodology uses the information extracted from both form structure and instances as a database reverse engineering input using an interaction with a user. Through a combination of forms structures and data instances analysis, forms relational sub-schemas and their constraints are derived. Th...
متن کاملRDBNorma: - A semi-automated tool for relational database schema normalization up to third normal form
In this paper a tool called RDBNorma is proposed, that uses a novel approach to represent a relational database schema and its functional dependencies in computer memory using only one linked list and used for semi-automating the process of relational database schema normalization up to third normal form. This paper addresses all the issues of representing a relational schema along with its fun...
متن کاملC Converting a Legacy Database to Object- Oriented Database
We present an approach to transfer content of an existing conventional relational database to a corresponding existing object-oriented database. The major motivation is having organizations with two generations of information systems; the first is based on the relational model, and the second is based on the object-oriented model. This has several drawbacks. First, it is impossible to get unifi...
متن کامل